<CFPARAM name="userid" default="1">

<cfquery datasource="#application.dsn#" name="getusers">
SELECT * FROM users
WHERE userid=#userid#  
</cfquery>

<CFOUTPUT>
<TABLE border="1" cellspacing="1" cellpadding="1" width="50%">

	<TR>
		<TD>username</TD>
		<TD>#getusers.username#</TD>
	</TR>
	<TR>
		<TD>password</TD>
		<TD>#getusers.password#</TD>
	</TR>
	<TR>
		<TD>name</TD>
		<TD>#getusers.name#</TD>
	</TR>
	<TR>
		<TD>email</TD>
		<TD>#getusers.email#</TD>
	</TR>
</TABLE>
</CFOUTPUT>
